﻿CREATE VIEW [ODData].[Trajectory_View_SeriesID_21]
AS
SELECT     S.VariableName, ObservationValue, S.Units, LocalDateTime,UTCOffsetHours, GeoPosition.STAsText() as GeoPosition from ODData.GetDataFromTrajectory(21) T INNER JOIN ODCore.SeriesCatalog_View S on S.SeriesID=21
